Querymaster Help Contents

Welcome to Querymaster on-line help. Click a topic below to jump to it.

 How To Order

CompuServe SWREG ID ==> 9423

Product Specifications

Overview

System Requirements

Disclaimer

Querymaster Main Form

Select Database

Max SQL

Clear SQL

ADD ...

CHG ...

DEL ...

Paste Table

Paste Column

Options

Template

Refresh

Print

Exit

Querymaster Options Form

SQL Window

Help Window

QueryDef Grid

Tables Grid

Columns Grid

Querymaster Reports

SQL Window

QueryDef List

Table List

Column List

Query Results Report

Querymaster Parameters Form

Parameterized QueryDefs

Querymaster Results Forms

SELECT Query Results

ACTION Query Results

Technical Support


Technical Support
Querymaster: Technical Support

If you experience any problems using Querymaster, or if you have a feature you would like to see in a future release, you can communicate with the Querymaster developers in several ways:

1. CompuServe: our address is 72417,627

2. America On-Line: our address is ISES, Inc.

3. Fax: Fax any queries to 908-580-1008

4. Voice: Call 1-800-447-ISES. The office is open 9-5, Mon-Fri (Eastern Time).

5. Mail: 	ISES, Inc.

102 Sunrise Drive

Gillette, NJ 07933


How To Order
Querymaster: How To Order

Check

Credit Card

SWREG


Ordering via SWREG
Ordering Querymaster via SWREG

To order your registered copy of Querymaster including full product source code and one free updrade

via CompuServe’s SWREG service, follow these steps:

1. Log on to Compuserve

2. Either from the services menu or the command prompt type “GO SWREG”.

3. Follow the instructions. Querymaster’s SWREG ID is ==> 9423


Ordering by Credit Card
Ordering Querymaster by Credit Card

To order your registered copy of Querymaster including full product source code and one free updrade,

have your credit card handy and call: 1-800-447-ISES.

To fax your order, print this form, fill it out, and fax it to: 908-580-1008.

To mail in your order, print this form, fill it out, and mail it to:

ISES, Inc.

102 Sunrise Drive

Gillette, NJ 07933

Thanks for your order !

Visa ____      Master Card ____    American Express _____	Sig:_________________________

CC# ________________________________	Exp Dt _______

1 computer @ $27 .................................................................................	_____________

2 thru 9 computers	____________	@ $24 each .......................	_____________

10 thru 99 computers 	____________	@ $21 each .......................	_____________

Unlimited site license @ $2500 .............................................................	_____________

$3 Shipping & Handling inside US ..........................................................	_____________

$5 Shipping & Handling outside US ........................................................	_____________

TOTAL ...................................................................................................	_____________

Ship To:	Name __________________________________________________________

Company _______________________________________________________

Address ________________________________________________________

________________________________________________________

City ___________________________________________________________

State ____________________     Zip _______________  Country _________


Ordering by Check
Ordering Querymaster by Check

To order your registered copy of Querymaster including full product source code and one free updrade, print this form, fill it out, and mail the form with check payable to ISES, Inc. to ...

ISES, Inc.

102 Sunrise Drive

Gillette, NJ 07933

Thanks for your order !

1 computer @ $27 .................................................................................	_____________

2 thru 9 computers	____________	@ $24 each .......................	_____________

10 thru 99 computers 	____________	@ $21 each .......................	_____________

Unlimited site license @ $2500 .............................................................	_____________

$3 Shipping & Handling inside US ..........................................................	_____________

$5 Shipping & Handling outside US ........................................................	_____________

TOTAL ...................................................................................................	_____________

Ship To:	Name __________________________________________________________

Company _______________________________________________________

Address ________________________________________________________

________________________________________________________

City ___________________________________________________________

State ____________________     Zip _______________  Country _________


Action Query Results
Querymaster: Action Query Results

When you run an “action” query (i.e., a query that updates the database but doesn’t return any rows), Querymaster will display the Action Query Results form when the query is finished.

This form shows the number of records affected by the query, and the amount of time it took for the query to execute.

The Action Query Results form also gives you a chance to “roll back” the changes the query has made to the database. This is useful when you need to run multiple tests when developing an action query.


Parameterized QueryDefs
Querymaster: Parameterized QueryDefs

When you run a query that requires parameters, Querymaster will prompt you for the parameter values by displaying the Querymaster Parameters form.

The parameters required by the query are listed in the parameters grid at the top of the form. The value you used for each parameter the last time the query was run is shown in the “Value” column in the parameter grid.

To add or change a parameter value, click on the cell containing the value you want to change. Querymaster will copy the value into the parameter edit window where you can make any necessary changes.

The “Sticky Parameters” button enables you to tell Querymaster whether you want previous parameter values loaded from the “permanent” query currently selected or from the “new” query you are developing.

In either case, any parameters entered will be permanently “remembered” by Querymaster for future recall.


Query Results Report
Querymaster: Query Results Report

When a query has executed that returns rows, the Querymaster results screen will be displayed.

You can create a report on the query results by clicking the “PRINT” button on the results screen.


Column List Report
Querymaster: Column List Report

You can print the contents of the Column Grid as follows:

From the Main Querymaster form, click “Print ...”.

On the Querymaster Print form, check the “Column List” box.

Click “OK” to bring up the standard Windows Print dialog box.


Table List Report
Querymaster: Table List Report

You can print the contents of the Table Grid as follows:

From the Main Querymaster form, click “Print ...”.

On the Querymaster Print form, check the “Table List” box.

Click “OK” to bring up the standard Windows Print dialog box.


QueryDef List Report
Querymaster: QueryDef List Report

You can print the contents of the QueryDef Grid as follows:

From the Main Querymaster form, click “Print ...”.

On the Querymaster Print form, check the “QueryDef List” box.

Click “OK” to bring up the standard Windows Print dialog box.


SQL Window Report
Querymaster: SQL Window Report

You can print the contents of the current SQL Window as follows:

From the Main Querymaster form, click “Print ...”.

On the Querymaster Print form, check the “SQL Statement” box.

Click “OK” to bring up the standard Windows Print dialog box.


Options: SQL Window
Querymaster: SQL Window Options

You can adjust the back color, fore color, and font of the SQL Window on the main Querymaster form.

Simply click “Options” on the main form to bring up the Querymaster Options form. Click the SQL Window radio button. Select the colors and font you want and click “SAVE”.


Options: Columns Grid
Querymaster: Column Grid Options

You can adjust the back color, fore color, and font of the Column Grid on the main Querymaster form.

Simply click “Options” on the main form to bring up the Querymaster Options form. Click the Column Grid radio button. Select the colors and font you want and click “SAVE”.


Options: Tables Grid
Querymaster: Table Grid Options

You can adjust the back color, fore color, and font of the Table Grid on the main Querymaster form.

Simply click “Options” on the main form to bring up the Querymaster Options form. Click the Table Grid radio button. Select the colors and font you want and click “SAVE”.


Options: QueryDef Grid
Querymaster: QueryDef Grid Options

You can adjust the back color, fore color, and font of the QueryDef Grid on the main Querymaster form.

Simply click “Options” on the main form to bring up the Querymaster Options form. Click the QueryDef Grid radio button. Select the colors and font you want and click “SAVE”.


Options: Help Window
Querymaster: Help Window Options

You can adjust the back color, fore color, and font of the Help Window on the main Querymaster form.

Simply click “Options” on the main form to bring up the Querymaster Options form. Click the Help Window radio button. Select the colors and font you want and click “SAVE”.


Exit Querymaster

Click EXIT to end your Querymaster session. If there are any outstanding changes in the current SQL window you will be prompted to save them.


Print (main form)
Querymaster: Printing Data from the Main Form

Use the PRINT button on the main form to bring up the Print selection form.

On the Print selection form you can print any combination of:

* The current SQL window

* The QueryDef grid

* The Table Grid

* The Column Grid


Refresh
Querymaster: Refreshing the Table, Column, and QueryDef Displays

Click the Refresh button to refresh the grids on the main form.

This is useful after running and committing an action query since it will update the row count column in the Table grid.


Template
Querymaster: Using a Template to Start a New Query

Click the Template button to bring up the template form when building a new SQL query.

On the Template form, you will be able to construct a syntactically correct “shell” of any SQL statement, from a DELETE FROM to a complex parameterized SELECT with joins and GROUP BY’s.

Simply check the SQL elements you want to include in your new query and click OK.


Options
Querymaster: Customizing the Grids and SQL Windows

The Querymaster Options screen gives you the ability to select the background, foreground and fonts for:

* The current SQL window

* The QueryDefs grid

* The Tables grid

* The Columns grid

* The “instant help” window

To customize your Querymaster desktop, click the Options button to enter the options form.

On the options form, select the component you want to work on from the “Apply To” list.

Pick the colors and fonts you like.

Click SAVE to make the selections permanent.


Paste Column
Querymaster: Pasting a Column Name into a QueryDef

You can paste a column name into the current SQL window using either of the following two methods:

THE SLOW WAY: Highlight the desired column name in the Column grid and click the Paste Column button.

THE FAST WAY: Double-click the desired column name in the Column grid.

If the “Paste Comma” box is checked, Querymaster will insert a comma after the column name in the current SQL window.

If the “Paste Table Prefix” box is checked, Querymaster will insert the table name and a “.” before the column name in the current SQL window.


Paste Table
Querymaster: Pasting a Table Name into a QueryDef

You can paste a table name into the current SQL window using either of the following two methods:

THE SLOW WAY: Highlight the desired table name in the Table grid and click the Paste Table button.

THE FAST WAY: Double-click the desired table name in the Table grid.

If the “Paste Comma” box is checked, Querymaster will insert a comma after the table name in the current SQL window.


Del ...
Querymaster: Deleting a QueryDef

When you click the DEL button, Querymaster will remove the query currently selected in the QueryDef grid from the database. You will be prompted to confirm the QueryDef delete  operation.


Chg ...
Querymaster: Changing a QueryDef

When you click on an existing QueryDef name in the QueryDef grid, the SQL associated with the QueryDef appears in the current SQL window.

You can make any modifications to the QueryDef that you wish, and then click on the CHG button to save your changes. Remember that you are free to test the changes using the RUN command before saving the changes.

Querymaster will prompt you for confirmation before committing the changes to the database.


Add ...
Querymaster: Adding a QueryDef to the Database

To create a new QueryDef, enter the SQL code for the query in the current SQL window. You can use the RUN command to test the query before saving it.

When you click the ADD button, Querymaster will prompt you for the new QueryDef’s name. After it has been added to the database, the new QueryDef name will be added to the QueryDef grid.


Clear SQL
Querymaster: Clear SQL

Click the Clear SQL button the erase the contents of the current SQL window. If there are any outstanding unsaved changes, Querymaster will prompt you before erasing your SQL code.


Max SQL/Norm SQL
Querymaster: Max SQL, Norm SQL

The current SQL window on the main Querymaster form is normally sized to permit the QueryDef grid, table name grid, and column name grid to be visible and accessable while the query is being developed.

If you want to maximize the SQL window real estate while developing the query, click the Max SQL button. This will expand the SQL window, covering up the supporting grids. To contract the window, click Norm SQL.


The source code accompanying this product is intended for the sole use of the registered owner.

The registered owner may load, modify, and customize this code to his/her heart’s content. However, if the registered owner desires to sell any product derived either directly or indirectly from this source code, he/she must contact the copyright holders of the original source code (ISES, Inc.) and obtain a letter of release or enter into a royalty agreement with the copyright holder.

No liability is assumed with respect to the use of this software. Although every precaution has been taken in the preparation of this product, the authors assume no responsibility for errors or omissions. Neither is any liability assumed for damages resulting from the use of this software. For information, address ISES, Inc. 1500 Route 202, PO Box 151, Basking Ridge, NJ 07920.


System Requirements
Querymaster: System Requirements

Querymaster requires the following:

* VB4 Professional or Enterprise Edition.

* 32-bit development environment (Win 95 or Win NT 3.51 or later)

* A developer who hates using Access for query development.

As for platform horsepower considerations, (RAM, disk space, etc.) it boils down to this. If you can run VB4 on the box, you can certainly run Querymaster.


Overview
Querymaster: System Overview

Querymaster is designed to dramatically improve the productivity of programmers who are developing 32-bit VB4 applications using Access MDB databases via the Jet 3.0 engine.

The Data Manager add-in that ships with VB4 is very good at defining databases, tables, indices and other system administration tasks. Unfortunately, support for imbedded SQL and QueryDef development is weak at best. Incredibly, support for parameterized QueryDef development is non-existent.

In the past, this forced developers to purchase Access just for QueryDef development. Besides being expensive, most experienced programmers loathe Access and use it only as a last resort. The only other alternative was the sample program VisData. While this provided good examples of Jet and ODBC code, it was buggy and cumbersome to use.

Enter Querymaster. The first tool designed specifically for the development and testing of imbedded SQL, QueryDefs and parameterized QueryDefs for 32-bit VB4 Jet 3.0 Access MDB developers. As you use Querymaster, some of the useful features you will find are:

* Paste table names and column names directly into SQL code from database lists. Querymaster 	     	automatically determines when [square brackets] are needed around object names.

* Templates to speed SELECT, INSERT, UPDATE, and DELETE query development.

* “Sticky” parameter values. Save parameter values on the Querymaster database.

* Custom user interface. Choose your own colors and fonts for Querymaster objects.

* COMMIT / ROLLBACK choice after testing action queries.

* Several useful reports about your queries.

* Context sensitive on-line help.

* Complete project source available for your use.

We hope you find Querymaster fun and productive to use. Please contact us if you have any questions or ideas for additional features.


Select Database
Querymaster: Selecting A Database

Click the “Sel. DB” button to bring up the standard open dialog box. Select the .MDB file and click OK.

Querymaster will load existing QueryDefs, table names, and column names into the grids on the main form. The (alphabetically) first QueryDef SQL will be automatically loaded into the current SQL window.